import openpyxl

fileName = r"C:\Download\新荣臣问题订单2 - 副本.xlsx"

xfile = openpyxl.load_workbook(fileName)
sheet = xfile['Sheet1']

col1 = [item.value for item in list(sheet.columns)[0]]
orderNo = col1[2:]

for i in range (len(orderNo)):
    sheet[f'K{i + 3}'] = "'" + orderNo[i] + "'" + ","

xfile.save(fileName)
